Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4

Alex The Analyst

600K subscribers

1.4M views 2 years ago Data Analyst Portfolio Projects

Take my Full MySQL Course Here: https://bit.ly/3tqOipr Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.

…

...more

...more

License

Creative Commons Attribution license (reuse allowed)

3,334 Comments

Add a comment...

Pinned by Alex The Analyst

@davidng9403

I'm doing this in Oct 2021 and apparently one of the code chunks where you need to convert new_vaccinations column to integer, the sum value now has exceeded 2,147,483,647. So instead of converting it to "int", you will need to convert to "bigint". Hope this helps everyone.

@katl3597

Hi Alex! Doing this in July 2023 and I think the SMSS features have changed a bit. Instead of using SQL Server Native Client 11.0 it is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import. Hope this helps!

@bwhle

This was a lifesaver when I needed a portfolio quickly for a job interview while still being a beginner. It was easy to follow and I could base my own projects on it. This definitely was part of me getting the job!

@alijokhio2995

To the ones stuck on 19:10 , use the following code to convert into float datatype when ''Null" Select location, date, total_cases,total_deaths, (CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage from PortfolioProject..covidDeaths order by 1,2

Read more

@agatanakoncuswiata

Man... you're amazing. Don't congratulate us to have stayed until the end! It's TONS of work you've done and it's only to be applauded and appreciated! I bet many agree with me - against your sore throat you guided us through soooo many ideas and possibilities! Thank you so much and wish you MILLIONS views!

·

@mariahhayes5089

Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.

@veronicab2096

2 years ago (edited)

I’ve just started the video and I’m about 9 minutes in. I wanted to stop at this point to tell you I’m glad you showed your mistake live. It’s important for beginners to see that experts also make mistakes. It is encouraging. As a bonus, I will better remember to save as xlsx because you pointed it out. So thank you for leaving that in.

·

@jackjeffries6872

For those using Mac and found MySql as their preferred option; before you import data, be sure to reformat the date to yyyy-mm-dd so that MySql recognizes the date as an actual date. To do this, highlight the column and press control+1, go to date and select the format I mentioned above. Hope this helps someone!

@BetterLife95

I just completely watched this priceless video. Many thanks Alex for teaching us free of cost and guiding us all along. I am an Economist and have been learning data analysis since 2022 and it is amazing that I have found your channel and you.

@zakhelembhele7046

I like these little mistakes you're making. Because of them, you're much more natural and it becomes more interesting. You're doing a GREAT job!

@jeremiahwooten226

I can’t express how much I appreciate you creating these tutorials. As a beginner prospective analyst looking to add projects to a portfolio, I was lost and overwhelmed. Your videos are a godsend. Thanks a lot

·

@bikramshrestha4233

For whoever is having trouble in inserting their data in temp table, make sure to have the same data type of the columns in the covidDeaths table and temp table. And I found it better to specify the columns that you're inserting data in as: INSERT INTO #PercentageOfVaccinatedPopulation(location,date,population,new_vaccinations,TotalInLocation)

@jjsinclair94

Great content, as per. You helped me to get my dream job as a modelling analyst in the last couple of weeks, I am forever grateful to you!

·

@sj1795

11 days ago (edited)

Alex, THANK YOU!!! I can't express my gratitude enough for everything you've done for us. I just made it through your SQL series (Beginner, Intermediate, & Advanced). Hooray! You make the process so simple and straightforward, which makes it SO easy to follow along. The project component is the BEST part. You're breaking down what we've learned and showing how we can actually use it. This is a HUGE missing link in today's education system. My Biomedical Engineering PhD program funding feel through (absolutely heartbreaking). I made it 2/3 of the way through and wrote 90 pages of a thesis that I was unable to use. While I was able to get a Master's degree, it was not in the subject/career I had wanted. My world was thrown upside down. I had no idea what I was going to do. Then, data analysis and YOU showed up in my life. You (and your "Become a Data Analyst" bootcamp) have served as a beacon of light and hope for my future. Bless you! And THANK YOU again!

Read more

@lloyddc6602

Thank you so much Alex. I have been drilling myself to learn a lot regarding data analytics for 2 months and I'm trying to put all the things that I learned together. This is by far the best I found online. By the way, I have similar background as yours. I also work in healthcare and transitioning to data analytics due to PTSD during the pandemic and other work related injury. Regards from Vancouver, Canada :)

@anastasiasokol566

Alex, thank you so much for creating and sharing this video! It is a great help and an inspiration! I have a question about the temp table and views that were in it: is there a part two of this project where there's visualisation with this data? Or is this project considered complete?

@brandijean5186

Thank you, Alex! I am impressed with myself for completing this project, though, I am not 100% sure the reasoning behind everything we did, which means I still have a lot of work to do. This was amazing for getting my hands dirty and jumping right in to this exciting new world of SQL. I am looking forward to using this as a reference to make more of my own, customized projects.

@user-xy9sq3lg7m

For the query at 58:56, I was getting an error: "Arithmetic overflow error converting expression to data type int. Warning: Null value is eliminated by an aggregate or other SET operation." For those of you getting the same thing, change the "int" into "bigint", apparently its due to the sum function.

@JordanVillarreal

I did data analysis and error management in a HUGE database for sprint. The work I did was extremely similar to this. The database was way messier and more confusing than this, but if you can work out the problems as you go like he is, this is basically what I did everyday.

@riinupiiinu

Firstly, thank you so much for all the resources you have. They are super helpful! I haven't finished this video yet but I'm following it along and it's really interesting since I'm doing the project now in 2023 and the dataset has changed a lot. I have a question though. I am at the point where you calculate % of vaccinations per population (1:06:10). If I do this calculation per country, I see that the US, for example, has a vaccination rate of over 200%. Would that indicate that the column new_vaccinations does not include unique vaccinations but also boosters? Thanks!

Read more

Introduction

Getting Out Dataset

Importing Datasets into SQL

Data Exploration

Import Code into GitHub

Naomi K.O

Public

0/140

30.0 seconds

Continue clipping after ad finishes

Can’t create clip while ad is playing

Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4

Alex The Analyst

28K

Likes

1,480,645

Views

2021

May 4

Take my Full MySQL Course Here: https://bit.ly/3tqOipr Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project. Link to GitHub: https://bit.ly/3xNwzGK Link to Dataset: https://ourworldindata.org/covid-deaths ** It appears the dataset may have been changed at the source. Please use these 2 links to get the data from the 2 excels: 1. Covid Deaths: https://github.com/AlexTheAnalyst/Por... 2. Covid Vaccinations: https://github.com/AlexTheAnalyst/Por... ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ RESOURCES: Coursera Courses: Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel! ____________________________________________ SUPPORT MY CHANNEL - PATREON/MERCH Patreon Page - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the... ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst ____________________________________________ All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for 0:00 Introduction 1:43 Getting Out Dataset 6:41 Importing Datasets into SQL 13:40 Data Exploration 1:13:35 Import Code into GitHub

Introduction

Getting Out Dataset

Importing Datasets into SQL

Data Exploration

Featured playlist

Data Analyst Portfolio Projects

Alex The Analyst

Music

SONG

Memory Card Full

ARTIST

Birocratic

ALBUM

Memory Card Full

LICENSES

Get YouTube Premium

Transcript

Follow along using the transcript.

Alex The Analyst

600K subscribers

SQL Basics for Data Analysts

by Alex The Analyst